class: center, middle <style type="text/css"> .main-container{ margin-top: 10px !important; /* margin-left: 10px !important; margin-right: 10px !important; margin-bottom: 10px !important; max-width: 100% !important;*/ } .output.plotly-container, .output.leaflet-container { width: 100%; lightable-classic { margin-left: 0; } .remark-slide table { margin: 0; border-top: 1px solid #666; border-bottom: 1px solid #666; } .green { color: green; } .orange { color: orange; } .darkorange { color: #ff5300; } .red { color: red; } </style> # Escondido Creek Water Quality Assessment .left[ <br><br><br> #### Richard Riemer<br> #### 2023-07-06 .footnote[Data Provided by San Diego Coastkeeper] ] --- Table 1. Five Locations Along Escondido Creek Plus Three in San Elijo Lagoon. .left[ <table class=" lightable-classic" style="font-family: Cambria; width: auto !important; "> <thead> <tr> <th style="text-align:left;"> StationName </th> <th style="text-align:left;"> StationCode </th> <th style="text-align:right;"> lat </th> <th style="text-align:right;"> lng </th> <th style="text-align:right;"> Distance </th> <th style="text-align:right;"> CumDist </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> Country Club Dr. </td> <td style="text-align:left;"> EDC-050 </td> <td style="text-align:right;"> 33.09908 </td> <td style="text-align:right;"> -117.1305 </td> <td style="text-align:right;"> 0.00 </td> <td style="text-align:right;"> 0.00 </td> </tr> <tr> <td style="text-align:left;"> Elfin Forest Park </td> <td style="text-align:left;"> EDC-040 </td> <td style="text-align:right;"> 33.08617 </td> <td style="text-align:right;"> -117.1455 </td> <td style="text-align:right;"> 1.24 </td> <td style="text-align:right;"> 1.24 </td> </tr> <tr> <td style="text-align:left;"> Questhaven Rd. </td> <td style="text-align:left;"> EDC-030 </td> <td style="text-align:right;"> 33.07181 </td> <td style="text-align:right;"> -117.1641 </td> <td style="text-align:right;"> 1.46 </td> <td style="text-align:right;"> 2.71 </td> </tr> <tr> <td style="text-align:left;"> El Camino Del N. </td> <td style="text-align:left;"> EDC-020 </td> <td style="text-align:right;"> 33.04825 </td> <td style="text-align:right;"> -117.2268 </td> <td style="text-align:right;"> 3.98 </td> <td style="text-align:right;"> 6.69 </td> </tr> <tr> <td style="text-align:left;"> S. Rancho Santa Fe </td> <td style="text-align:left;"> EDC-010 </td> <td style="text-align:right;"> 33.03389 </td> <td style="text-align:right;"> -117.2356 </td> <td style="text-align:right;"> 1.12 </td> <td style="text-align:right;"> 7.80 </td> </tr> <tr> <td style="text-align:left;"> Dike </td> <td style="text-align:left;"> SEL-030 </td> <td style="text-align:right;"> 33.01283 </td> <td style="text-align:right;"> -117.2599 </td> <td style="text-align:right;"> 2.02 </td> <td style="text-align:right;"> 9.83 </td> </tr> <tr> <td style="text-align:left;"> San Elijo Lagoon </td> <td style="text-align:left;"> SEL-020 </td> <td style="text-align:right;"> 33.01303 </td> <td style="text-align:right;"> -117.2747 </td> <td style="text-align:right;"> 0.86 </td> <td style="text-align:right;"> 10.68 </td> </tr> <tr> <td style="text-align:left;"> Cardif Beach </td> <td style="text-align:left;"> SEL-010 </td> <td style="text-align:right;"> 33.01439 </td> <td style="text-align:right;"> -117.2809 </td> <td style="text-align:right;"> 0.37 </td> <td style="text-align:right;"> 11.05 </td> </tr> </tbody> </table> ] --- Figure 1. Map of Monitoring Locations In Escondido Creek Watershed.
--- Table 1. Descriptive Statistics for Analytes Measured at Elfin Forest Way-up Trail. <br> With Bacteria Thresholds and Effect Size for Month or Location as a Predictor. <table class=" lightable-classic" style="font-family: Cambria; width: auto !important; "> <thead> <tr> <th style="empty-cells: hide;border-bottom:hidden;" colspan="1"></th> <th style="empty-cells: hide;border-bottom:hidden;" colspan="4"></th> <th style="border-bottom:hidden;padding-bottom:0; padding-left:3px;padding-right:3px;text-align: center; " colspan="2"><div style="border-bottom: 1px solid #ddd; padding-bottom: 5px; ">GeoMean5</div></th> <th style="border-bottom:hidden;padding-bottom:0; padding-left:3px;padding-right:3px;text-align: center; " colspan="2"><div style="border-bottom: 1px solid #ddd; padding-bottom: 5px; ">Effect Size</div></th> </tr> <tr> <th style="text-align:left;"> Analyte_Unit </th> <th style="text-align:right;"> n </th> <th style="text-align:right;"> median </th> <th style="text-align:right;"> mean </th> <th style="text-align:right;"> sd </th> <th style="text-align:right;"> mean </th> <th style="text-align:right;"> sd </th> <th style="text-align:right;"> Month </th> <th style="text-align:right;"> Location </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> Temperature (Deg F) </td> <td style="text-align:right;"> 455 </td> <td style="text-align:right;"> 62.96 </td> <td style="text-align:right;"> 62.76 </td> <td style="text-align:right;"> 7.13 </td> <td style="text-align:right;"> 62.55 </td> <td style="text-align:right;"> 4.60 </td> <td style="text-align:right;"> 67.00 </td> <td style="text-align:right;"> 0.56 </td> </tr> <tr> <td style="text-align:left;"> Oxygen_ Dissolved_ Not Recorde (mg/L) </td> <td style="text-align:right;"> 78 </td> <td style="text-align:right;"> 7.91 </td> <td style="text-align:right;"> 7.94 </td> <td style="text-align:right;"> 1.35 </td> <td style="text-align:right;"> 8.04 </td> <td style="text-align:right;"> 0.87 </td> <td style="text-align:right;"> 61.22 </td> <td style="text-align:right;"> 25.38 </td> </tr> <tr> <td style="text-align:left;"> ElectricalConductivity_ Total (uS/cm) </td> <td style="text-align:right;"> 353 </td> <td style="text-align:right;"> 1993.33 </td> <td style="text-align:right;"> 2049.25 </td> <td style="text-align:right;"> 576.16 </td> <td style="text-align:right;"> 1956.26 </td> <td style="text-align:right;"> 436.56 </td> <td style="text-align:right;"> 30.16 </td> <td style="text-align:right;"> 21.52 </td> </tr> <tr> <td style="text-align:left;"> Enterococcus (MPN/100 mL) </td> <td style="text-align:right;"> 383 </td> <td style="text-align:right;"> 161.00 </td> <td style="text-align:right;"> 1269.97 </td> <td style="text-align:right;"> 4341.37 </td> <td style="text-align:right;"> 249.02 </td> <td style="text-align:right;"> 187.42 </td> <td style="text-align:right;"> 28.58 </td> <td style="text-align:right;"> 0.40 </td> </tr> <tr> <td style="text-align:left;"> E. coli (MPN/100 mL) </td> <td style="text-align:right;"> 412 </td> <td style="text-align:right;"> 120.00 </td> <td style="text-align:right;"> 623.20 </td> <td style="text-align:right;"> 1964.63 </td> <td style="text-align:right;"> 166.61 </td> <td style="text-align:right;"> 108.62 </td> <td style="text-align:right;"> 22.07 </td> <td style="text-align:right;"> 0.41 </td> </tr> <tr> <td style="text-align:left;"> OrthoPhosphate as P_ Dissolved (mg/L) </td> <td style="text-align:right;"> 345 </td> <td style="text-align:right;"> 0.07 </td> <td style="text-align:right;"> 0.10 </td> <td style="text-align:right;"> 0.07 </td> <td style="text-align:right;"> 0.08 </td> <td style="text-align:right;"> 0.03 </td> <td style="text-align:right;"> 18.68 </td> <td style="text-align:right;"> 7.80 </td> </tr> <tr> <td style="text-align:left;"> Phosphorus as P_ Dissolved (mg/L) </td> <td style="text-align:right;"> 401 </td> <td style="text-align:right;"> 0.08 </td> <td style="text-align:right;"> 0.09 </td> <td style="text-align:right;"> 0.05 </td> <td style="text-align:right;"> 0.08 </td> <td style="text-align:right;"> 0.03 </td> <td style="text-align:right;"> 17.30 </td> <td style="text-align:right;"> 19.05 </td> </tr> <tr> <td style="text-align:left;"> Coliform_ Total (MPN/100 mL) </td> <td style="text-align:right;"> 405 </td> <td style="text-align:right;"> 2873.00 </td> <td style="text-align:right;"> 5800.33 </td> <td style="text-align:right;"> 6900.16 </td> <td style="text-align:right;"> 3509.02 </td> <td style="text-align:right;"> 2011.83 </td> <td style="text-align:right;"> 17.21 </td> <td style="text-align:right;"> 1.91 </td> </tr> <tr> <td style="text-align:left;"> Nitrate as N_ Dissolved (mg/L) </td> <td style="text-align:right;"> 423 </td> <td style="text-align:right;"> 3.33 </td> <td style="text-align:right;"> 3.49 </td> <td style="text-align:right;"> 2.29 </td> <td style="text-align:right;"> 3.23 </td> <td style="text-align:right;"> 1.91 </td> <td style="text-align:right;"> 16.60 </td> <td style="text-align:right;"> 37.23 </td> </tr> <tr> <td style="text-align:left;"> Turbidity_ Total (NTU) </td> <td style="text-align:right;"> 282 </td> <td style="text-align:right;"> 0.79 </td> <td style="text-align:right;"> 28.12 </td> <td style="text-align:right;"> 248.61 </td> <td style="text-align:right;"> 2.01 </td> <td style="text-align:right;"> 2.86 </td> <td style="text-align:right;"> 12.71 </td> <td style="text-align:right;"> 0.78 </td> </tr> <tr> <td style="text-align:left;"> Ammonia as N_ Dissolved (mg/L) </td> <td style="text-align:right;"> 409 </td> <td style="text-align:right;"> 0.02 </td> <td style="text-align:right;"> 0.03 </td> <td style="text-align:right;"> 0.05 </td> <td style="text-align:right;"> 0.03 </td> <td style="text-align:right;"> 0.01 </td> <td style="text-align:right;"> 3.63 </td> <td style="text-align:right;"> 2.95 </td> </tr> <tr> <td style="text-align:left;"> pH (none) </td> <td style="text-align:right;"> 441 </td> <td style="text-align:right;"> 8.20 </td> <td style="text-align:right;"> 8.19 </td> <td style="text-align:right;"> 0.29 </td> <td style="text-align:right;"> 8.20 </td> <td style="text-align:right;"> 0.21 </td> <td style="text-align:right;"> 2.68 </td> <td style="text-align:right;"> 24.50 </td> </tr> </tbody> </table> * GeoMean5: Mean and standard deviation of a geometric moving average based on five consecutive samples. <!-- * p_unsf_gm5: Proportion of unsafe levels in the gm5. Unsafe levels for bacteria listed below. --> <!-- * p_unsf_ss: Proportion of unsafe levels in the single sample value (ss). --> * Effect Size (0%-100%): The effect size of the month and location of the sample. <!-- The Effect size can range from 0% to 100% and is a measure of the amount of variability accounted for by a predictor variable. --> --- Table 2. Proportion of Unsafe Single Sample Results and Five Sample GeoMetric Means. <table class=" lightable-classic" style="font-family: Cambria; width: auto !important; "> <thead> <tr> <th style="empty-cells: hide;border-bottom:hidden;" colspan="1"></th> <th style="empty-cells: hide;border-bottom:hidden;" colspan="3"></th> <th style="border-bottom:hidden;padding-bottom:0; padding-left:3px;padding-right:3px;text-align: center; " colspan="2"><div style="border-bottom: 1px solid #ddd; padding-bottom: 5px; ">Threshold</div></th> <th style="border-bottom:hidden;padding-bottom:0; padding-left:3px;padding-right:3px;text-align: center; " colspan="2"><div style="border-bottom: 1px solid #ddd; padding-bottom: 5px; ">Proportion</div></th> </tr> <tr> <th style="text-align:left;"> Analyte_Unit </th> <th style="text-align:right;"> n </th> <th style="text-align:right;"> ss-mean </th> <th style="text-align:right;"> gm5 </th> <th style="text-align:right;"> ss </th> <th style="text-align:right;"> gm5 </th> <th style="text-align:right;"> ss </th> <th style="text-align:right;"> gm5 </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> Coliform_ Total (MPN/100 mL) </td> <td style="text-align:right;"> 405 </td> <td style="text-align:right;"> 5800.33 </td> <td style="text-align:right;"> 3509.02 </td> <td style="text-align:right;"> 10000 </td> <td style="text-align:right;"> 1000 </td> <td style="text-align:right;"> 0.18 </td> <td style="text-align:right;"> 0.99 </td> </tr> <tr> <td style="text-align:left;"> Enterococcus (MPN/100 mL) </td> <td style="text-align:right;"> 383 </td> <td style="text-align:right;"> 1269.97 </td> <td style="text-align:right;"> 249.02 </td> <td style="text-align:right;"> 110 </td> <td style="text-align:right;"> 30 </td> <td style="text-align:right;"> 0.64 </td> <td style="text-align:right;"> 1.00 </td> </tr> <tr> <td style="text-align:left;"> E. coli (MPN/100 mL) </td> <td style="text-align:right;"> 412 </td> <td style="text-align:right;"> 623.20 </td> <td style="text-align:right;"> 166.61 </td> <td style="text-align:right;"> 320 </td> <td style="text-align:right;"> 100 </td> <td style="text-align:right;"> 0.20 </td> <td style="text-align:right;"> 0.69 </td> </tr> </tbody> </table> * Total Coliform Bacteria concentrations exceeding 10,000 CFU*/100mL for a single sample or 1,000 CFU/100mL for the geometric mean are considered unsafe for limited water contact recreation. Estimated Illness Rate is 32 per 1,000 water contact recreators. * CFU/100mL: Colony-forming units (CFU) per 100 milliliters (100mL) of water. -- * Enterococcus Bacteria concentrations exceeding 110 CFU/100mL for a single sample or 30 CFU/100mL for the geometric mean are considered unsafe. * Escherichia coli (E. coli) concentrations exceeding 320 CFU/100mL for a single sample or 100 CFU/100mL for the geometric mean considered unsafe. -- * 2018 San Diego Regional Harbor Monitoring Program: Final Report Historical Bacteria Analysis Wood Project No. 1715100804 December 2020. Historical California regulations for bacteria do not specify or distinguish between MPN and CFU, and the units are assumed to be equivalent for regulatory analysis and compliance. * STATE WATER RESOURCES CONTROL BOARD CALIFORNIA ENVIRONMENTAL PROTECTION AGENCY. Part 3 of the Water Quality Control Plan for Inland Surface Waters, Enclosed Bays, and Estuaries of California: Bacteria Provisions and a Water Quality Standards Variance Policy, February 4, 2019. .red[We need confirmation that the SDCK sampling methods are consistent with these quality standards.] --- ### The following sides contain plots of single sample and geometric mean results collected between January 2009 and October 2018. * Benchmarks and standards are included to assess the health of the riparian habitat and safety for limited human water recreation. * The riparian benchmarks correspond to fresh water mayfly larvae. * Depending on availability, the benchmarks and standards include up-to four value ranges .red[(these standards resulted from internet searches and applicability to SDCK sampling methods need to be confirmed)]: 1. Optimal 2. Can cause some toxicity 3. Can cause significant toxicity 4. Can be fatal --- .pull-left[ #### Temperature (°F) #### Ranges for mayfly larvae. ] .pull-right[ * .green[Optimal Range 50 - 68 ] * .orange[Can Cause Some Toxicity Range 45 - 49 ] * .darkorange[Can Cause Significant Toxicity Range 69 - 75 ] * .red[Can Be Fatal Range < 45 or > 75 ] ]
--- .pull-left[ #### Disolved Oxygen Total (mg/L) #### Ranges for mayfly larvae. ] .pull-right[ * .green[Optimal Range > 7 ] * .orange[Can Cause Some Toxicity Range 6 - 7 ] * .darkorange[Can Cause Significant Toxicity Range 4-5 ] * .red[Can Be Fatal Range <4 ] ]
--- .pull-left[ #### Disolved Oxygen Not Recorded (mg/L) #### Ranges for mayfly larvae. ] .pull-right[ * .green[Optimal Range > 7 ] * .orange[Can Cause Some Toxicity Range 6 - 7 ] * .darkorange[Can Cause Significant Toxicity Range 4-5 ] * .red[Can Be Fatal Range <4 ] ]
--- .pull-left[ #### Electrical Conductivity (µS/cm) #### Ranges for mayfly larvae. ] .pull-right[ * .green[Optimal Range < 500 ] * .orange[Can Cause Some Toxicity Range 500 - 800 ] * .darkorange[Can Cause Significant Toxicity Range 800 - 1500 ] ]
--- .pull-left[ #### Enterococcus (CFU/100mL) #### Ranges for limited human recreation in fresh water.] .pull-right[ * .green[Optimal Range < 35 ] * .orange[Can Cause Some Toxicity Range 36 - 70 ] * .darkorange[Can Cause Significant Toxicity Range 71 - 150 ] ]
--- .pull-left[ #### Enterococcus Geometric Mean5 (CFU/100mL) #### Ranges for limited human recreation in fresh water.] .pull-right[ * .green[Optimal Range < 35 ] * .orange[Can Cause Some Toxicity Range 36 - 70 ] * .darkorange[Can Cause Significant Toxicity Range 71 - 150 ] ]
--- .pull-left[ #### E. coli (CFU/100mL) #### Ranges for limited human recreation in fresh water.] .pull-right[ * .green[Optimal Range < 126 ] * .orange[Can Cause Some Toxicity Range 127 - 235 ] * .darkorange[Can Cause Significant Toxicity Range 236 - 406 ] ]
--- .pull-left[ #### E. coli Geometric Mean5 (CFU/100mL) #### Ranges for limited human recreation in fresh water.] .pull-right[ * .green[Optimal Range < 126 ] * .orange[Can Cause Some Toxicity Range 127 - 235 ] * .darkorange[Can Cause Significant Toxicity Range 236 - 406 ] ]
--- .pull-left[ #### Coliform Total (CFU/100mL) #### Ranges for limited human recreation in fresh water.] .pull-right[ * .green[Optimal Range < 200 ] * .orange[Can Cause Some Toxicity Range 201 - 400 ] * .darkorange[Can Cause Significant Toxicity Range 401 - 1000 ] ]
--- .pull-left[ #### Coliform Total Geometric Mean5 (CFU/100mL) #### Ranges for limited human recreation in fresh water.] .pull-right[ * .green[Optimal Range < 200 ] * .orange[Can Cause Some Toxicity Range 201 - 400 ] * .darkorange[Can Cause Significant Toxicity Range 401 - 1000 ] ]
--- .pull-left[ #### OrthoPhosphate as P Dissolved (mg/L) #### Ranges for mayfly larvae.] .pull-right[ * .green[Optimal Range < 0.1 ] * .orange[Can Cause Some Toxicity Range 0.1 - 0.5 ] * .darkorange[Can Cause Significant Toxicity Range 0.5 - 1.0 ] ]
--- .pull-left[ #### Phosphorus as P Dissolved (mg/L) #### Ranges for mayfly larvae.] .pull-right[ * .green[Optimal Range < 0.03 ] * .orange[Can Cause Some Toxicity Range 0.03 - 0.1 ] * .darkorange[Can Cause Significant Toxicity Range 0.1 - 0.3 ] ]
--- .pull-left[ #### Nitrate as N Dissolved (mg/L) #### Ranges for mayfly larvae.] .pull-right[ * .green[Optimal Range < 1 ] * .orange[Can Cause Some Toxicity Range 1 - 5 ] * .darkorange[Can Cause Significant Toxicity Range 5 - 10 ] ]
--- .pull-left[ #### Turbidity Total (NTU) #### Ranges for mayfly larvae.] .pull-right[ * .green[Optimal Range < 5 ] * .orange[Can Cause Some Toxicity Range 5 - 10 ] * .darkorange[Can Cause Significant Toxicity Range 10 - 25 ] ]
--- .pull-left[ #### Ammonia as N Dissolved (mg/L) #### Ranges for mayfly larvae.] .pull-right[ * .green[Optimal Range < 0.02 ] * .orange[Can Cause Some Toxicity Range 0.02 - 0.05 ] * .darkorange[Can Cause Significant Toxicity Range 0.05 - 0.1 ] ]
--- .pull-left[ #### pH (mg/L) #### Ranges for mayfly larvae.] .pull-right[ * .green[Optimal Range 6.5 - 8.0 ] * .orange[Can Cause Some Toxicity Range > 8.0 ] ]